set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区

insert overwrite table jms_dim.dim_ep_center_person_base
select
id
,site_code
,site_name
,code
,name
,status
,rank
,organization_authority_code
,create_by
,create_by_name
,create_time
,modify_by
,modify_by_name
,modify_time
,remark
,type
,organization_authority_name
,agent_code
,agent_name
,outsource_company_id
,outsource_company_name
,operate_code
,operate_name
,id_card
,place_type_code
,place_type_name
,sex
,mobile
,register_status
,supplier_code
,id_card_enc
,post_id
,post_name
,post_code
,department_id
,department_name
from jms_ods.ep_center_person
where dt= '{{ execution_date | cst_ds }}'
distribute by 1 ;